Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL
1) Aggregate Functions
2) Analytical Functions
3) Constraints
4) Cursor
5) Data Set
6) Data Type
7) Database
8) Date Timezone
9) Index
10) Insert Delete Update
11) Math Functions
12) Select Query
13) Sequence
14) Store Procedure Function
15) String Functions
16) Subquery
17) System
18) Table
19) Table Joins
20) Transact SQL
21) Transaction
22) Trigger
23) View
24) XML

Constraints
1) A statement that creates a table with two column-level check constraints
2) A unique constraint
3) Add a default value of 0 if no value specified
4) Add a nullable column
5) Add a primary key to a table
6) Add check constaint to only allow positive value
7) Add constraints for two columns
8) Add Default value constraint
9) Add Unique constaint to table creation
10) Adding a Foreign Key to an Existing Table
11) Adding a UNIQUE Constraint to an Existing Table
12) Blocking Empty and Missing Character Input
13) Changing a Column Definition
14) Check constraints coded at the table level
15) CHECK Constraints for current date
16) Check the value range
17) Combine two columns as the primary key
18) Constraint
19) Constraint check (Options)
20) Create Rules
21) Creating a Primary Key on an Existing Table
22) Data length
23) Define Primary key and foreign key
24) Define Primary key in table creation command
25) DELETE CASCADE and UPDATE CASCADE
26) Enable a column to optionally not require a value by designating it as a nullable column
27) use foreign key constraints
28) Maintenance of the referential constraint
29) Mark constraint with nocheck when creating a constraint
30) Not Allowing Null Values in a Column
31) NOT NULL column and NULL column
32) Sample Code for Disabling a Constraint
33) Set default value for column
34) Specification of the primary key of the employee table as a column-level constraint
35) Table-level constraints
36) The syntax of a check constraint
37) Two constraints for one single column
38) UniqueIdentifier are either explicitly provided or they are generated by the NEWID() system function
39) WITH CHECK OPTION says any INSERT or UPDATE statements must meet that where clause criteria